Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 21597 |
| Missing cells | 6281 |
| Missing cells (%) | 1.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 15 |
|---|---|
| DateTime | 1 |
| Boolean | 1 |
| Categorical | 3 |
| Text | 1 |
price is highly overall correlated with sqft_living and 2 other fields | High correlation |
bedrooms is highly overall correlated with bathrooms and 2 other fields | High correlation |
bathrooms is highly overall correlated with bedrooms and 5 other fields | High correlation |
sqft_living is highly overall correlated with price and 4 other fields | High correlation |
sqft_lot is highly overall correlated with sqft_lot15 | High correlation |
floors is highly overall correlated with bathrooms and 2 other fields | High correlation |
sqft_above is highly overall correlated with price and 5 other fields | High correlation |
yr_built is highly overall correlated with bathrooms and 1 other fields | High correlation |
zipcode is highly overall correlated with long | High correlation |
long is highly overall correlated with zipcode | High correlation |
sqft_living15 is highly overall correlated with price and 3 other fields | High correlation |
sqft_lot15 is highly overall correlated with sqft_lot | High correlation |
waterfront is highly overall correlated with view | High correlation |
view is highly overall correlated with waterfront | High correlation |
waterfront is highly imbalanced (93.6%) | Imbalance |
view is highly imbalanced (72.3%) | Imbalance |
waterfront has 2376 (11.0%) missing values | Missing |
yr_renovated has 3842 (17.8%) missing values | Missing |
yr_renovated has 17011 (78.8%) zeros | Zeros |
Reproduction
| Analysis started | 2023-10-23 08:47:40.820110 |
|---|---|
| Analysis finished | 2023-10-23 08:48:04.131658 |
| Duration | 23.31 seconds |
| Software version | ydata-profiling vv4.6.0 |
| Download configuration | config.json |
id
Real number (ℝ)
| Distinct | 21420 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5804743 × 109 |
| Minimum | 1000102 |
|---|---|
| Maximum | 9.9000002 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 5.1274039 × 108 |
| Q1 | 2.1230492 × 109 |
| median | 3.9049304 × 109 |
| Q3 | 7.3089005 × 109 |
| 95-th percentile | 9.2973004 × 109 |
| Maximum | 9.9000002 × 109 |
| Range | 9.8990001 × 109 |
| Interquartile range (IQR) | 5.1858513 × 109 |
Descriptive statistics
| Standard deviation | 2.8767357 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.6280432 |
| Kurtosis | -1.2607499 |
| Mean | 4.5804743 × 109 |
| Median Absolute Deviation (MAD) | 2.4025303 × 109 |
| Skewness | 0.24322552 |
| Sum | 9.8924503 × 1013 |
| Variance | 8.2756084 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 795000620 | 3 | < 0.1% |
| 8910500150 | 2 | < 0.1% |
| 7409700215 | 2 | < 0.1% |
| 1995200200 | 2 | < 0.1% |
| 9211500620 | 2 | < 0.1% |
| 1524079093 | 2 | < 0.1% |
| 4305200070 | 2 | < 0.1% |
| 1450100390 | 2 | < 0.1% |
| 7893805650 | 2 | < 0.1% |
| 109200390 | 2 | < 0.1% |
| Other values (21410) | 21576 |
| Value | Count | Frequency (%) |
| 1000102 | 2 | |
| 1200019 | 1 | |
| 1200021 | 1 | |
| 2800031 | 1 | |
| 3600057 | 1 | |
| 3600072 | 1 | |
| 3800008 | 1 | |
| 5200087 | 1 | |
| 6200017 | 1 | |
| 7200080 | 1 |
| Value | Count | Frequency (%) |
| 9900000190 | 1 | |
| 9895000040 | 1 | |
| 9842300540 | 1 | |
| 9842300485 | 1 | |
| 9842300095 | 1 | |
| 9842300036 | 1 | |
| 9839301165 | 1 | |
| 9839301060 | 1 | |
| 9839301055 | 1 | |
| 9839300875 | 1 |
date
Date
| Distinct | 372 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.9 KiB |
| Minimum | 2014-05-02 00:00:00 |
|---|---|
| Maximum | 2015-05-27 00:00:00 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 3622 |
|---|---|
| Distinct (%) | 16.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 540296.57 |
| Minimum | 78000 |
|---|---|
| Maximum | 7700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 78000 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 322000 |
| median | 450000 |
| Q3 | 645000 |
| 95-th percentile | 1160000 |
| Maximum | 7700000 |
| Range | 7622000 |
| Interquartile range (IQR) | 323000 |
Descriptive statistics
| Standard deviation | 367368.14 |
|---|---|
| Coefficient of variation (CV) | 0.67993794 |
| Kurtosis | 34.541359 |
| Mean | 540296.57 |
| Median Absolute Deviation (MAD) | 150000 |
| Skewness | 4.0233647 |
| Sum | 1.1668785 × 1010 |
| Variance | 1.3495935 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 450000 | 172 | 0.8% |
| 350000 | 172 | 0.8% |
| 550000 | 159 | 0.7% |
| 500000 | 152 | 0.7% |
| 425000 | 150 | 0.7% |
| 325000 | 148 | 0.7% |
| 400000 | 145 | 0.7% |
| 375000 | 138 | 0.6% |
| 300000 | 133 | 0.6% |
| 525000 | 131 | 0.6% |
| Other values (3612) | 20097 |
| Value | Count | Frequency (%) |
| 78000 | 1 | |
| 80000 | 1 | |
| 81000 | 1 | |
| 82000 | 1 | |
| 82500 | 1 | |
| 83000 | 1 | |
| 84000 | 1 | |
| 85000 | 2 | |
| 86500 | 1 | |
| 89000 | 1 |
| Value | Count | Frequency (%) |
| 7700000 | 1 | |
| 7060000 | 1 | |
| 6890000 | 1 | |
| 5570000 | 1 | |
| 5350000 | 1 | |
| 5300000 | 1 | |
| 5110000 | 1 | |
| 4670000 | 1 | |
| 4500000 | 1 | |
| 4490000 | 1 |
bedrooms
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3732 |
| Minimum | 1 |
|---|---|
| Maximum | 33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 32 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.92629889 |
|---|---|
| Coefficient of variation (CV) | 0.27460539 |
| Kurtosis | 49.821835 |
| Mean | 3.3732 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.0236412 |
| Sum | 72851 |
| Variance | 0.85802964 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 9824 | |
| 4 | 6882 | |
| 2 | 2760 | 12.8% |
| 5 | 1601 | 7.4% |
| 6 | 272 | 1.3% |
| 1 | 196 | 0.9% |
| 7 | 38 | 0.2% |
| 8 | 13 | 0.1% |
| 9 | 6 | < 0.1% |
| 10 | 3 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 196 | 0.9% |
| 2 | 2760 | 12.8% |
| 3 | 9824 | |
| 4 | 6882 | |
| 5 | 1601 | 7.4% |
| 6 | 272 | 1.3% |
| 7 | 38 | 0.2% |
| 8 | 13 | 0.1% |
| 9 | 6 | < 0.1% |
| 10 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 33 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 9 | 6 | < 0.1% |
| 8 | 13 | 0.1% |
| 7 | 38 | 0.2% |
| 6 | 272 | 1.3% |
| 5 | 1601 | 7.4% |
| 4 | 6882 | |
| 3 | 9824 |
bathrooms
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1158263 |
| Minimum | 0.5 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 7.5 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.7689843 |
|---|---|
| Coefficient of variation (CV) | 0.36344397 |
| Kurtosis | 1.2793153 |
| Mean | 2.1158263 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.51970928 |
| Sum | 45695.5 |
| Variance | 0.59133685 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.5 | 5377 | |
| 1 | 3851 | |
| 1.75 | 3048 | |
| 2.25 | 2047 | 9.5% |
| 2 | 1930 | 8.9% |
| 1.5 | 1445 | 6.7% |
| 2.75 | 1185 | 5.5% |
| 3 | 753 | 3.5% |
| 3.5 | 731 | 3.4% |
| 3.25 | 589 | 2.7% |
| Other values (19) | 641 | 3.0% |
| Value | Count | Frequency (%) |
| 0.5 | 4 | < 0.1% |
| 0.75 | 71 | 0.3% |
| 1 | 3851 | |
| 1.25 | 9 | < 0.1% |
| 1.5 | 1445 | 6.7% |
| 1.75 | 3048 | |
| 2 | 1930 | 8.9% |
| 2.25 | 2047 | 9.5% |
| 2.5 | 5377 | |
| 2.75 | 1185 | 5.5% |
| Value | Count | Frequency (%) |
| 8 | 2 | < 0.1% |
| 7.75 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 6.75 | 2 | < 0.1% |
| 6.5 | 2 | < 0.1% |
| 6.25 | 2 | < 0.1% |
| 6 | 6 | |
| 5.75 | 4 | < 0.1% |
| 5.5 | 10 | |
| 5.25 | 13 |
sqft_living
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1034 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2080.3219 |
| Minimum | 370 |
|---|---|
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1430 |
| median | 1910 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13170 |
| Interquartile range (IQR) | 1120 |
Descriptive statistics
| Standard deviation | 918.10613 |
|---|---|
| Coefficient of variation (CV) | 0.44132889 |
| Kurtosis | 5.252102 |
| Mean | 2080.3219 |
| Median Absolute Deviation (MAD) | 540 |
| Skewness | 1.4732155 |
| Sum | 44928711 |
| Variance | 842918.86 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1300 | 138 | 0.6% |
| 1400 | 135 | 0.6% |
| 1440 | 133 | 0.6% |
| 1800 | 129 | 0.6% |
| 1660 | 129 | 0.6% |
| 1010 | 129 | 0.6% |
| 1820 | 128 | 0.6% |
| 1480 | 125 | 0.6% |
| 1720 | 125 | 0.6% |
| 1540 | 124 | 0.6% |
| Other values (1024) | 20302 |
| Value | Count | Frequency (%) |
| 370 | 1 | |
| 380 | 1 | |
| 390 | 1 | |
| 410 | 1 | |
| 420 | 2 | |
| 430 | 1 | |
| 440 | 1 | |
| 460 | 1 | |
| 470 | 2 | |
| 480 | 2 |
| Value | Count | Frequency (%) |
| 13540 | 1 | |
| 12050 | 1 | |
| 10040 | 1 | |
| 9890 | 1 | |
| 9640 | 1 | |
| 9200 | 1 | |
| 8670 | 1 | |
| 8020 | 1 | |
| 8010 | 1 | |
| 8000 | 1 |
sqft_lot
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 9776 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15099.409 |
| Minimum | 520 |
|---|---|
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1800.8 |
| Q1 | 5040 |
| median | 7618 |
| Q3 | 10685 |
| 95-th percentile | 43307.2 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5645 |
Descriptive statistics
| Standard deviation | 41412.637 |
|---|---|
| Coefficient of variation (CV) | 2.7426661 |
| Kurtosis | 285.49581 |
| Mean | 15099.409 |
| Median Absolute Deviation (MAD) | 2618 |
| Skewness | 13.072604 |
| Sum | 3.2610193 × 108 |
| Variance | 1.7150065 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 358 | 1.7% |
| 6000 | 290 | 1.3% |
| 4000 | 251 | 1.2% |
| 7200 | 220 | 1.0% |
| 4800 | 119 | 0.6% |
| 7500 | 119 | 0.6% |
| 4500 | 114 | 0.5% |
| 8400 | 111 | 0.5% |
| 9600 | 109 | 0.5% |
| 3600 | 103 | 0.5% |
| Other values (9766) | 19803 |
| Value | Count | Frequency (%) |
| 520 | 1 | |
| 572 | 1 | |
| 600 | 1 | |
| 609 | 1 | |
| 635 | 1 | |
| 638 | 1 | |
| 649 | 2 | |
| 651 | 1 | |
| 675 | 1 | |
| 676 | 1 |
| Value | Count | Frequency (%) |
| 1651359 | 1 | |
| 1164794 | 1 | |
| 1074218 | 1 | |
| 1024068 | 1 | |
| 982998 | 1 | |
| 982278 | 1 | |
| 920423 | 1 | |
| 881654 | 1 | |
| 871200 | 2 | |
| 843309 | 1 |
floors
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4940964 |
| Minimum | 1 |
|---|---|
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.53968279 |
|---|---|
| Coefficient of variation (CV) | 0.36121015 |
| Kurtosis | -0.49106576 |
| Mean | 1.4940964 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.61449698 |
| Sum | 32268 |
| Variance | 0.29125751 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 10673 | |
| 2 | 8235 | |
| 1.5 | 1910 | 8.8% |
| 3 | 611 | 2.8% |
| 2.5 | 161 | 0.7% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 10673 | |
| 1.5 | 1910 | 8.8% |
| 2 | 8235 | |
| 2.5 | 161 | 0.7% |
| 3 | 611 | 2.8% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.5 | 7 | < 0.1% |
| 3 | 611 | 2.8% |
| 2.5 | 161 | 0.7% |
| 2 | 8235 | |
| 1.5 | 1910 | 8.8% |
| 1 | 10673 |
waterfront
Boolean
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2376 |
| Missing (%) | 11.0% |
| Memory size | 42.3 KiB |
| False | |
|---|---|
| True | 146 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 19075 | |
| True | 146 | 0.7% |
| (Missing) | 2376 | 11.0% |
view
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 63 |
| Missing (%) | 0.3% |
| Memory size | 168.9 KiB |
| NONE | |
|---|---|
| AVERAGE | 957 |
| GOOD | 508 |
| FAIR | 330 |
| EXCELLENT | 317 |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 4.2069286 |
| Min length | 4 |
Characters and Unicode
| Total characters | 90592 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NONE |
|---|---|
| 2nd row | NONE |
| 3rd row | NONE |
| 4th row | NONE |
| 5th row | NONE |
Common Values
| Value | Count | Frequency (%) |
| NONE | 19422 | |
| AVERAGE | 957 | 4.4% |
| GOOD | 508 | 2.4% |
| FAIR | 330 | 1.5% |
| EXCELLENT | 317 | 1.5% |
| (Missing) | 63 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| none | 19422 | |
| average | 957 | 4.4% |
| good | 508 | 2.4% |
| fair | 330 | 1.5% |
| excellent | 317 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 39161 | |
| E | 22287 | |
| O | 20438 | |
| A | 2244 | 2.5% |
| G | 1465 | 1.6% |
| R | 1287 | 1.4% |
| V | 957 | 1.1% |
| L | 634 | 0.7% |
| D | 508 | 0.6% |
| F | 330 | 0.4% |
| Other values (4) | 1281 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 90592 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 39161 | |
| E | 22287 | |
| O | 20438 | |
| A | 2244 | 2.5% |
| G | 1465 | 1.6% |
| R | 1287 | 1.4% |
| V | 957 | 1.1% |
| L | 634 | 0.7% |
| D | 508 | 0.6% |
| F | 330 | 0.4% |
| Other values (4) | 1281 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 90592 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 39161 | |
| E | 22287 | |
| O | 20438 | |
| A | 2244 | 2.5% |
| G | 1465 | 1.6% |
| R | 1287 | 1.4% |
| V | 957 | 1.1% |
| L | 634 | 0.7% |
| D | 508 | 0.6% |
| F | 330 | 0.4% |
| Other values (4) | 1281 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 90592 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 39161 | |
| E | 22287 | |
| O | 20438 | |
| A | 2244 | 2.5% |
| G | 1465 | 1.6% |
| R | 1287 | 1.4% |
| V | 957 | 1.1% |
| L | 634 | 0.7% |
| D | 508 | 0.6% |
| F | 330 | 0.4% |
| Other values (4) | 1281 | 1.4% |
condition
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.9 KiB |
| Average | |
|---|---|
| Good | |
| Very Good | |
| Fair | 170 |
| Poor | 29 |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.3412974 |
| Min length | 4 |
Characters and Unicode
| Total characters | 136953 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Average |
|---|---|
| 2nd row | Average |
| 3rd row | Average |
| 4th row | Very Good |
| 5th row | Average |
Common Values
| Value | Count | Frequency (%) |
| Average | 14020 | |
| Good | 5677 | |
| Very Good | 1701 | 7.9% |
| Fair | 170 | 0.8% |
| Poor | 29 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| average | 14020 | |
| good | 7378 | |
| very | 1701 | 7.3% |
| fair | 170 | 0.7% |
| poor | 29 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29741 | |
| r | 15920 | |
| o | 14814 | |
| a | 14190 | |
| A | 14020 | |
| v | 14020 | |
| g | 14020 | |
| G | 7378 | 5.4% |
| d | 7378 | 5.4% |
| V | 1701 | 1.2% |
| Other values (5) | 3771 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 111954 | |
| Uppercase Letter | 23298 | 17.0% |
| Space Separator | 1701 | 1.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 29741 | |
| r | 15920 | |
| o | 14814 | |
| a | 14190 | |
| v | 14020 | |
| g | 14020 | |
| d | 7378 | 6.6% |
| y | 1701 | 1.5% |
| i | 170 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 14020 | |
| G | 7378 | |
| V | 1701 | 7.3% |
| F | 170 | 0.7% |
| P | 29 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1701 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 135252 | |
| Common | 1701 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 29741 | |
| r | 15920 | |
| o | 14814 | |
| a | 14190 | |
| A | 14020 | |
| v | 14020 | |
| g | 14020 | |
| G | 7378 | 5.5% |
| d | 7378 | 5.5% |
| V | 1701 | 1.3% |
| Other values (4) | 2070 | 1.5% |
Common
| Value | Count | Frequency (%) |
| 1701 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 136953 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 29741 | |
| r | 15920 | |
| o | 14814 | |
| a | 14190 | |
| A | 14020 | |
| v | 14020 | |
| g | 14020 | |
| G | 7378 | 5.4% |
| d | 7378 | 5.4% |
| V | 1701 | 1.2% |
| Other values (5) | 3771 | 2.8% |
grade
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.9 KiB |
| 7 Average | |
|---|---|
| 8 Good | |
| 9 Better | |
| 6 Low Average | |
| 10 Very Good | |
| Other values (6) | 771 |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 8.5886929 |
| Min length | 5 |
Characters and Unicode
| Total characters | 185490 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 7 Average |
|---|---|
| 2nd row | 7 Average |
| 3rd row | 6 Low Average |
| 4th row | 7 Average |
| 5th row | 8 Good |
Common Values
| Value | Count | Frequency (%) |
| 7 Average | 8974 | |
| 8 Good | 6065 | |
| 9 Better | 2615 | 12.1% |
| 6 Low Average | 2038 | 9.4% |
| 10 Very Good | 1134 | 5.3% |
| 11 Excellent | 399 | 1.8% |
| 5 Fair | 242 | 1.1% |
| 12 Luxury | 89 | 0.4% |
| 4 Low | 27 | 0.1% |
| 13 Mansion | 13 | 0.1% |
Length
| Value | Count | Frequency (%) |
| average | 11012 | |
| 7 | 8974 | |
| good | 7199 | |
| 8 | 6065 | |
| 9 | 2615 | 5.6% |
| better | 2615 | 5.6% |
| low | 2065 | 4.5% |
| 6 | 2038 | 4.4% |
| 10 | 1134 | 2.4% |
| very | 1134 | 2.4% |
| Other values (11) | 1515 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29186 | |
| 24769 | ||
| o | 16478 | |
| r | 15093 | 8.1% |
| a | 11267 | 6.1% |
| A | 11012 | 5.9% |
| v | 11012 | 5.9% |
| g | 11012 | 5.9% |
| 7 | 8974 | 4.8% |
| d | 7199 | 3.9% |
| Other values (27) | 39488 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 112720 | |
| Space Separator | 24769 | 13.4% |
| Uppercase Letter | 24769 | 13.4% |
| Decimal Number | 23232 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 29186 | |
| o | 16478 | |
| r | 15093 | |
| a | 11267 | 10.0% |
| v | 11012 | 9.8% |
| g | 11012 | 9.8% |
| d | 7199 | 6.4% |
| t | 5629 | 5.0% |
| w | 2065 | 1.8% |
| y | 1223 | 1.1% |
| Other values (7) | 2556 | 2.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 8974 | |
| 8 | 6065 | |
| 9 | 2615 | 11.3% |
| 6 | 2038 | 8.8% |
| 1 | 2034 | 8.8% |
| 0 | 1134 | 4.9% |
| 5 | 242 | 1.0% |
| 2 | 89 | 0.4% |
| 4 | 27 | 0.1% |
| 3 | 14 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 11012 | |
| G | 7199 | |
| B | 2615 | 10.6% |
| L | 2154 | 8.7% |
| V | 1134 | 4.6% |
| E | 399 | 1.6% |
| F | 242 | 1.0% |
| M | 13 | 0.1% |
| P | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 24769 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 137489 | |
| Common | 48001 | 25.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 29186 | |
| o | 16478 | |
| r | 15093 | |
| a | 11267 | 8.2% |
| A | 11012 | 8.0% |
| v | 11012 | 8.0% |
| g | 11012 | 8.0% |
| d | 7199 | 5.2% |
| G | 7199 | 5.2% |
| t | 5629 | 4.1% |
| Other values (16) | 12402 |
Common
| Value | Count | Frequency (%) |
| 24769 | ||
| 7 | 8974 | 18.7% |
| 8 | 6065 | 12.6% |
| 9 | 2615 | 5.4% |
| 6 | 2038 | 4.2% |
| 1 | 2034 | 4.2% |
| 0 | 1134 | 2.4% |
| 5 | 242 | 0.5% |
| 2 | 89 | 0.2% |
| 4 | 27 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 185490 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 29186 | |
| 24769 | ||
| o | 16478 | |
| r | 15093 | 8.1% |
| a | 11267 | 6.1% |
| A | 11012 | 5.9% |
| v | 11012 | 5.9% |
| g | 11012 | 5.9% |
| 7 | 8974 | 4.8% |
| d | 7199 | 3.9% |
| Other values (27) | 39488 |
sqft_above
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 942 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1788.5968 |
| Minimum | 370 |
|---|---|
| Maximum | 9410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1190 |
| median | 1560 |
| Q3 | 2210 |
| 95-th percentile | 3400 |
| Maximum | 9410 |
| Range | 9040 |
| Interquartile range (IQR) | 1020 |
Descriptive statistics
| Standard deviation | 827.75976 |
|---|---|
| Coefficient of variation (CV) | 0.4627984 |
| Kurtosis | 3.4055198 |
| Mean | 1788.5968 |
| Median Absolute Deviation (MAD) | 450 |
| Skewness | 1.4474342 |
| Sum | 38628326 |
| Variance | 685186.22 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1300 | 212 | 1.0% |
| 1010 | 210 | 1.0% |
| 1200 | 206 | 1.0% |
| 1220 | 192 | 0.9% |
| 1140 | 184 | 0.9% |
| 1400 | 180 | 0.8% |
| 1060 | 178 | 0.8% |
| 1180 | 177 | 0.8% |
| 1340 | 176 | 0.8% |
| 1250 | 174 | 0.8% |
| Other values (932) | 19708 |
| Value | Count | Frequency (%) |
| 370 | 1 | < 0.1% |
| 380 | 1 | < 0.1% |
| 390 | 1 | < 0.1% |
| 410 | 1 | < 0.1% |
| 420 | 2 | |
| 430 | 1 | < 0.1% |
| 440 | 1 | < 0.1% |
| 460 | 1 | < 0.1% |
| 470 | 2 | |
| 480 | 4 |
| Value | Count | Frequency (%) |
| 9410 | 1 | |
| 8860 | 1 | |
| 8570 | 1 | |
| 8020 | 1 | |
| 7880 | 1 | |
| 7850 | 1 | |
| 7680 | 1 | |
| 7420 | 1 | |
| 7320 | 1 | |
| 6720 | 1 |
sqft_basement
Text
| Distinct | 304 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.9 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.8160393 |
| Min length | 1 |
Characters and Unicode
| Total characters | 82415 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 89 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 400.0 |
| 3rd row | 0.0 |
| 4th row | 910.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 12826 | |
| 454 | 2.1% | |
| 600.0 | 217 | 1.0% |
| 500.0 | 209 | 1.0% |
| 700.0 | 208 | 1.0% |
| 800.0 | 201 | 0.9% |
| 400.0 | 184 | 0.9% |
| 1000.0 | 148 | 0.7% |
| 900.0 | 142 | 0.7% |
| 300.0 | 142 | 0.7% |
| Other values (294) | 6866 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 44732 | |
| . | 21143 | |
| 1 | 3208 | 3.9% |
| 5 | 1818 | 2.2% |
| 2 | 1751 | 2.1% |
| 4 | 1708 | 2.1% |
| 8 | 1639 | 2.0% |
| 6 | 1602 | 1.9% |
| 7 | 1554 | 1.9% |
| 3 | 1522 | 1.8% |
| Other values (2) | 1738 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 60818 | |
| Other Punctuation | 21597 | 26.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 44732 | |
| 1 | 3208 | 5.3% |
| 5 | 1818 | 3.0% |
| 2 | 1751 | 2.9% |
| 4 | 1708 | 2.8% |
| 8 | 1639 | 2.7% |
| 6 | 1602 | 2.6% |
| 7 | 1554 | 2.6% |
| 3 | 1522 | 2.5% |
| 9 | 1284 | 2.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 21143 | |
| ? | 454 | 2.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 82415 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 44732 | |
| . | 21143 | |
| 1 | 3208 | 3.9% |
| 5 | 1818 | 2.2% |
| 2 | 1751 | 2.1% |
| 4 | 1708 | 2.1% |
| 8 | 1639 | 2.0% |
| 6 | 1602 | 1.9% |
| 7 | 1554 | 1.9% |
| 3 | 1522 | 1.8% |
| Other values (2) | 1738 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82415 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 44732 | |
| . | 21143 | |
| 1 | 3208 | 3.9% |
| 5 | 1818 | 2.2% |
| 2 | 1751 | 2.1% |
| 4 | 1708 | 2.1% |
| 8 | 1639 | 2.0% |
| 6 | 1602 | 1.9% |
| 7 | 1554 | 1.9% |
| 3 | 1522 | 1.8% |
| Other values (2) | 1738 | 2.1% |
yr_built
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1970.9997 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1951 |
| median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 29.375234 |
|---|---|
| Coefficient of variation (CV) | 0.014903723 |
| Kurtosis | -0.65769443 |
| Mean | 1970.9997 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.46944998 |
| Sum | 42567680 |
| Variance | 862.90438 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2014 | 559 | 2.6% |
| 2006 | 453 | 2.1% |
| 2005 | 450 | 2.1% |
| 2004 | 433 | 2.0% |
| 2003 | 420 | 1.9% |
| 2007 | 417 | 1.9% |
| 1977 | 417 | 1.9% |
| 1978 | 387 | 1.8% |
| 1968 | 381 | 1.8% |
| 2008 | 367 | 1.7% |
| Other values (106) | 17313 |
| Value | Count | Frequency (%) |
| 1900 | 87 | |
| 1901 | 29 | 0.1% |
| 1902 | 27 | 0.1% |
| 1903 | 46 | |
| 1904 | 45 | |
| 1905 | 74 | |
| 1906 | 92 | |
| 1907 | 65 | |
| 1908 | 86 | |
| 1909 | 94 |
| Value | Count | Frequency (%) |
| 2015 | 38 | 0.2% |
| 2014 | 559 | |
| 2013 | 201 | 0.9% |
| 2012 | 170 | 0.8% |
| 2011 | 130 | 0.6% |
| 2010 | 143 | 0.7% |
| 2009 | 230 | |
| 2008 | 367 | |
| 2007 | 417 | |
| 2006 | 453 |
yr_renovated
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 3842 |
| Missing (%) | 17.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.636778 |
| Minimum | 0 |
|---|---|
| Maximum | 2015 |
| Zeros | 17011 |
| Zeros (%) | 78.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 399.94641 |
|---|---|
| Coefficient of variation (CV) | 4.7819443 |
| Kurtosis | 18.919543 |
| Mean | 83.636778 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.5733852 |
| Sum | 1484971 |
| Variance | 159957.13 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 17011 | |
| 2014 | 73 | 0.3% |
| 2013 | 31 | 0.1% |
| 2003 | 31 | 0.1% |
| 2007 | 30 | 0.1% |
| 2000 | 29 | 0.1% |
| 2005 | 29 | 0.1% |
| 2004 | 22 | 0.1% |
| 1990 | 22 | 0.1% |
| 2009 | 21 | 0.1% |
| Other values (60) | 456 | 2.1% |
| (Missing) | 3842 | 17.8% |
| Value | Count | Frequency (%) |
| 0 | 17011 | |
| 1934 | 1 | < 0.1% |
| 1940 | 2 | < 0.1% |
| 1944 | 1 | < 0.1% |
| 1945 | 3 | < 0.1% |
| 1946 | 1 | < 0.1% |
| 1948 | 1 | < 0.1% |
| 1950 | 1 | < 0.1% |
| 1951 | 1 | < 0.1% |
| 1953 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2015 | 14 | 0.1% |
| 2014 | 73 | |
| 2013 | 31 | |
| 2012 | 8 | < 0.1% |
| 2011 | 9 | < 0.1% |
| 2010 | 15 | 0.1% |
| 2009 | 21 | 0.1% |
| 2008 | 15 | 0.1% |
| 2007 | 30 | |
| 2006 | 20 | 0.1% |
zipcode
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98077.952 |
| Minimum | 98001 |
|---|---|
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| median | 98065 |
| Q3 | 98118 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 53.513072 |
|---|---|
| Coefficient of variation (CV) | 0.00054561776 |
| Kurtosis | -0.85400486 |
| Mean | 98077.952 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 0.40532219 |
| Sum | 2.1181895 × 109 |
| Variance | 2863.6489 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98103 | 602 | 2.8% |
| 98038 | 589 | 2.7% |
| 98115 | 583 | 2.7% |
| 98052 | 574 | 2.7% |
| 98117 | 553 | 2.6% |
| 98042 | 547 | 2.5% |
| 98034 | 545 | 2.5% |
| 98118 | 507 | 2.3% |
| 98023 | 499 | 2.3% |
| 98006 | 498 | 2.3% |
| Other values (60) | 16100 |
| Value | Count | Frequency (%) |
| 98001 | 361 | |
| 98002 | 199 | 0.9% |
| 98003 | 280 | |
| 98004 | 317 | |
| 98005 | 168 | 0.8% |
| 98006 | 498 | |
| 98007 | 141 | 0.7% |
| 98008 | 283 | |
| 98010 | 100 | 0.5% |
| 98011 | 195 | 0.9% |
| Value | Count | Frequency (%) |
| 98199 | 317 | |
| 98198 | 280 | |
| 98188 | 136 | 0.6% |
| 98178 | 262 | |
| 98177 | 255 | |
| 98168 | 269 | |
| 98166 | 254 | |
| 98155 | 446 | |
| 98148 | 57 | 0.3% |
| 98146 | 288 |
lat
Real number (ℝ)
| Distinct | 5033 |
|---|---|
| Distinct (%) | 23.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.560093 |
| Minimum | 47.1559 |
|---|---|
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.4711 |
| median | 47.5718 |
| Q3 | 47.678 |
| 95-th percentile | 47.7497 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.2069 |
Descriptive statistics
| Standard deviation | 0.13855177 |
|---|---|
| Coefficient of variation (CV) | 0.0029131938 |
| Kurtosis | -0.67579021 |
| Mean | 47.560093 |
| Median Absolute Deviation (MAD) | 0.1049 |
| Skewness | -0.48552159 |
| Sum | 1027155.3 |
| Variance | 0.019196592 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47.5491 | 17 | 0.1% |
| 47.6846 | 17 | 0.1% |
| 47.5322 | 17 | 0.1% |
| 47.6624 | 17 | 0.1% |
| 47.6711 | 16 | 0.1% |
| 47.6955 | 16 | 0.1% |
| 47.6886 | 16 | 0.1% |
| 47.6647 | 15 | 0.1% |
| 47.6904 | 15 | 0.1% |
| 47.686 | 15 | 0.1% |
| Other values (5023) | 21436 |
| Value | Count | Frequency (%) |
| 47.1559 | 1 | |
| 47.1593 | 1 | |
| 47.1622 | 1 | |
| 47.1647 | 1 | |
| 47.1764 | 1 | |
| 47.1775 | 1 | |
| 47.1776 | 2 | |
| 47.1795 | 1 | |
| 47.1803 | 1 | |
| 47.1808 | 1 |
| Value | Count | Frequency (%) |
| 47.7776 | 3 | |
| 47.7775 | 3 | |
| 47.7774 | 1 | < 0.1% |
| 47.7772 | 3 | |
| 47.7771 | 2 | < 0.1% |
| 47.777 | 2 | < 0.1% |
| 47.7769 | 3 | |
| 47.7768 | 2 | < 0.1% |
| 47.7767 | 6 | |
| 47.7766 | 4 |
long
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 751 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.21398 |
| Minimum | -122.519 |
|---|---|
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 21597 |
| Negative (%) | 100.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.231 |
| Q3 | -122.125 |
| 95-th percentile | -121.9798 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.14072353 |
|---|---|
| Coefficient of variation (CV) | -0.001151452 |
| Kurtosis | 1.0521203 |
| Mean | -122.21398 |
| Median Absolute Deviation (MAD) | 0.101 |
| Skewness | 0.88488834 |
| Sum | -2639455.4 |
| Variance | 0.019803112 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -122.29 | 115 | 0.5% |
| -122.3 | 111 | 0.5% |
| -122.362 | 104 | 0.5% |
| -122.291 | 100 | 0.5% |
| -122.372 | 99 | 0.5% |
| -122.363 | 99 | 0.5% |
| -122.288 | 98 | 0.5% |
| -122.357 | 96 | 0.4% |
| -122.284 | 95 | 0.4% |
| -122.365 | 94 | 0.4% |
| Other values (741) | 20586 |
| Value | Count | Frequency (%) |
| -122.519 | 1 | < 0.1% |
| -122.515 | 1 | < 0.1% |
| -122.514 | 1 | < 0.1% |
| -122.512 | 1 | < 0.1% |
| -122.511 | 2 | |
| -122.509 | 2 | |
| -122.507 | 1 | < 0.1% |
| -122.506 | 1 | < 0.1% |
| -122.505 | 3 | |
| -122.504 | 2 |
| Value | Count | Frequency (%) |
| -121.315 | 2 | |
| -121.316 | 1 | |
| -121.319 | 1 | |
| -121.321 | 1 | |
| -121.325 | 1 | |
| -121.352 | 2 | |
| -121.359 | 1 | |
| -121.364 | 2 | |
| -121.402 | 1 | |
| -121.403 | 1 |
sqft_living15
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 777 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1986.6203 |
| Minimum | 399 |
|---|---|
| Maximum | 6210 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| median | 1840 |
| Q3 | 2360 |
| 95-th percentile | 3300 |
| Maximum | 6210 |
| Range | 5811 |
| Interquartile range (IQR) | 870 |
Descriptive statistics
| Standard deviation | 685.23047 |
|---|---|
| Coefficient of variation (CV) | 0.34492271 |
| Kurtosis | 1.5917328 |
| Mean | 1986.6203 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 1.1068754 |
| Sum | 42905039 |
| Variance | 469540.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1540 | 197 | 0.9% |
| 1440 | 195 | 0.9% |
| 1560 | 192 | 0.9% |
| 1500 | 180 | 0.8% |
| 1460 | 169 | 0.8% |
| 1580 | 167 | 0.8% |
| 1610 | 166 | 0.8% |
| 1720 | 166 | 0.8% |
| 1800 | 166 | 0.8% |
| 1620 | 164 | 0.8% |
| Other values (767) | 19835 |
| Value | Count | Frequency (%) |
| 399 | 1 | < 0.1% |
| 460 | 2 | < 0.1% |
| 620 | 2 | < 0.1% |
| 670 | 1 | < 0.1% |
| 690 | 2 | < 0.1% |
| 700 | 2 | < 0.1% |
| 710 | 2 | < 0.1% |
| 720 | 2 | < 0.1% |
| 740 | 8 | |
| 750 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 6210 | 1 | < 0.1% |
| 6110 | 1 | < 0.1% |
| 5790 | 6 | |
| 5610 | 1 | < 0.1% |
| 5600 | 1 | < 0.1% |
| 5500 | 1 | < 0.1% |
| 5380 | 1 | < 0.1% |
| 5340 | 1 | < 0.1% |
| 5330 | 1 | < 0.1% |
| 5220 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 8682 |
|---|---|
| Distinct (%) | 40.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12758.284 |
| Minimum | 651 |
|---|---|
| Maximum | 871200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 2002.4 |
| Q1 | 5100 |
| median | 7620 |
| Q3 | 10083 |
| 95-th percentile | 37045.2 |
| Maximum | 871200 |
| Range | 870549 |
| Interquartile range (IQR) | 4983 |
Descriptive statistics
| Standard deviation | 27274.442 |
|---|---|
| Coefficient of variation (CV) | 2.137783 |
| Kurtosis | 151.39566 |
| Mean | 12758.284 |
| Median Absolute Deviation (MAD) | 2505 |
| Skewness | 9.524362 |
| Sum | 2.7554065 × 108 |
| Variance | 7.4389518 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 427 | 2.0% |
| 4000 | 356 | 1.6% |
| 6000 | 288 | 1.3% |
| 7200 | 210 | 1.0% |
| 4800 | 145 | 0.7% |
| 7500 | 142 | 0.7% |
| 8400 | 116 | 0.5% |
| 3600 | 111 | 0.5% |
| 4500 | 111 | 0.5% |
| 5100 | 109 | 0.5% |
| Other values (8672) | 19582 |
| Value | Count | Frequency (%) |
| 651 | 1 | < 0.1% |
| 659 | 1 | < 0.1% |
| 660 | 1 | < 0.1% |
| 748 | 2 | |
| 750 | 4 | |
| 755 | 1 | < 0.1% |
| 757 | 1 | < 0.1% |
| 758 | 1 | < 0.1% |
| 788 | 1 | < 0.1% |
| 794 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 871200 | 1 | |
| 858132 | 1 | |
| 560617 | 1 | |
| 438213 | 1 | |
| 434728 | 1 | |
| 425581 | 1 | |
| 422967 | 1 | |
| 411962 | 1 | |
| 392040 | 2 | |
| 386812 | 1 |
| id | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | sqft_above | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | waterfront | view | condition | grade | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | 0.004 | 0.006 | 0.015 | 0.002 | -0.117 | 0.019 | 0.004 | 0.027 | -0.013 | -0.005 | -0.004 | 0.007 | 0.000 | -0.115 | 0.006 | 0.029 | 0.030 | 0.037 |
| price | 0.004 | 1.000 | 0.344 | 0.497 | 0.644 | 0.075 | 0.322 | 0.542 | 0.102 | 0.106 | -0.009 | 0.456 | 0.064 | 0.572 | 0.063 | 0.333 | 0.207 | 0.023 | 0.295 |
| bedrooms | 0.006 | 0.344 | 1.000 | 0.521 | 0.648 | 0.217 | 0.228 | 0.540 | 0.181 | 0.014 | -0.168 | -0.022 | 0.193 | 0.444 | 0.202 | 0.016 | 0.038 | 0.012 | 0.081 |
| bathrooms | 0.015 | 0.497 | 0.521 | 1.000 | 0.746 | 0.069 | 0.548 | 0.691 | 0.568 | 0.042 | -0.205 | 0.008 | 0.262 | 0.571 | 0.064 | 0.109 | 0.111 | 0.122 | 0.310 |
| sqft_living | 0.002 | 0.644 | 0.648 | 0.746 | 1.000 | 0.305 | 0.401 | 0.843 | 0.353 | 0.053 | -0.207 | 0.031 | 0.285 | 0.747 | 0.285 | 0.151 | 0.147 | 0.056 | 0.369 |
| sqft_lot | -0.117 | 0.075 | 0.217 | 0.069 | 0.305 | 1.000 | -0.234 | 0.273 | -0.037 | 0.005 | -0.319 | -0.122 | 0.371 | 0.360 | 0.922 | 0.022 | 0.041 | 0.040 | 0.042 |
| floors | 0.019 | 0.322 | 0.228 | 0.548 | 0.401 | -0.234 | 1.000 | 0.599 | 0.551 | 0.010 | -0.062 | 0.024 | 0.149 | 0.306 | -0.231 | 0.017 | 0.022 | 0.178 | 0.245 |
| sqft_above | 0.004 | 0.542 | 0.540 | 0.691 | 0.843 | 0.273 | 0.599 | 1.000 | 0.472 | 0.029 | -0.279 | -0.026 | 0.386 | 0.697 | 0.255 | 0.084 | 0.089 | 0.106 | 0.359 |
| yr_built | 0.027 | 0.102 | 0.181 | 0.568 | 0.353 | -0.037 | 0.551 | 0.472 | 1.000 | -0.216 | -0.317 | -0.126 | 0.413 | 0.336 | -0.016 | 0.035 | 0.042 | 0.248 | 0.195 |
| yr_renovated | -0.013 | 0.106 | 0.014 | 0.042 | 0.053 | 0.005 | 0.010 | 0.029 | -0.216 | 1.000 | 0.068 | 0.028 | -0.080 | -0.004 | 0.005 | 0.085 | 0.106 | 0.069 | 0.019 |
| zipcode | -0.005 | -0.009 | -0.168 | -0.205 | -0.207 | -0.319 | -0.062 | -0.279 | -0.317 | 0.068 | 1.000 | 0.249 | -0.577 | -0.287 | -0.326 | 0.078 | 0.074 | 0.074 | 0.110 |
| lat | -0.004 | 0.456 | -0.022 | 0.008 | 0.031 | -0.122 | 0.024 | -0.026 | -0.126 | 0.028 | 0.249 | 1.000 | -0.143 | 0.027 | -0.116 | 0.033 | 0.068 | 0.057 | 0.116 |
| long | 0.007 | 0.064 | 0.193 | 0.262 | 0.285 | 0.371 | 0.149 | 0.386 | 0.413 | -0.080 | -0.577 | -0.143 | 1.000 | 0.381 | 0.373 | 0.092 | 0.085 | 0.081 | 0.101 |
| sqft_living15 | 0.000 | 0.572 | 0.444 | 0.571 | 0.747 | 0.360 | 0.306 | 0.697 | 0.336 | -0.004 | -0.287 | 0.027 | 0.381 | 1.000 | 0.366 | 0.092 | 0.147 | 0.062 | 0.326 |
| sqft_lot15 | -0.115 | 0.063 | 0.202 | 0.064 | 0.285 | 0.922 | -0.231 | 0.255 | -0.016 | 0.005 | -0.326 | -0.116 | 0.373 | 0.366 | 1.000 | 0.000 | 0.035 | 0.013 | 0.038 |
| waterfront | 0.006 | 0.333 | 0.016 | 0.109 | 0.151 | 0.022 | 0.017 | 0.084 | 0.035 | 0.085 | 0.078 | 0.033 | 0.092 | 0.092 | 0.000 | 1.000 | 0.599 | 0.019 | 0.129 |
| view | 0.029 | 0.207 | 0.038 | 0.111 | 0.147 | 0.041 | 0.022 | 0.089 | 0.042 | 0.106 | 0.074 | 0.068 | 0.085 | 0.147 | 0.035 | 0.599 | 1.000 | 0.025 | 0.142 |
| condition | 0.030 | 0.023 | 0.012 | 0.122 | 0.056 | 0.040 | 0.178 | 0.106 | 0.248 | 0.069 | 0.074 | 0.057 | 0.081 | 0.062 | 0.013 | 0.019 | 0.025 | 1.000 | 0.128 |
| grade | 0.037 | 0.295 | 0.081 | 0.310 | 0.369 | 0.042 | 0.245 | 0.359 | 0.195 | 0.019 | 0.110 | 0.116 | 0.101 | 0.326 | 0.038 | 0.129 | 0.142 | 0.128 | 1.000 |
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 7129300520 | 10/13/2014 | 221900.0 | 3 | 1.00 | 1180 | 5650 | 1.0 | NaN | NONE | Average | 7 Average | 1180 | 0.0 | 1955 | 0.0 | 98178 | 47.5112 | -122.257 | 1340 | 5650 |
| 1 | 6414100192 | 12/9/2014 | 538000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | NO | NONE | Average | 7 Average | 2170 | 400.0 | 1951 | 1991.0 | 98125 | 47.7210 | -122.319 | 1690 | 7639 |
| 2 | 5631500400 | 2/25/2015 | 180000.0 | 2 | 1.00 | 770 | 10000 | 1.0 | NO | NONE | Average | 6 Low Average | 770 | 0.0 | 1933 | NaN | 98028 | 47.7379 | -122.233 | 2720 | 8062 |
| 3 | 2487200875 | 12/9/2014 | 604000.0 | 4 | 3.00 | 1960 | 5000 | 1.0 | NO | NONE | Very Good | 7 Average | 1050 | 910.0 | 1965 | 0.0 | 98136 | 47.5208 | -122.393 | 1360 | 5000 |
| 4 | 1954400510 | 2/18/2015 | 510000.0 | 3 | 2.00 | 1680 | 8080 | 1.0 | NO | NONE | Average | 8 Good | 1680 | 0.0 | 1987 | 0.0 | 98074 | 47.6168 | -122.045 | 1800 | 7503 |
| 5 | 7237550310 | 5/12/2014 | 1230000.0 | 4 | 4.50 | 5420 | 101930 | 1.0 | NO | NONE | Average | 11 Excellent | 3890 | 1530.0 | 2001 | 0.0 | 98053 | 47.6561 | -122.005 | 4760 | 101930 |
| 6 | 1321400060 | 6/27/2014 | 257500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | NO | NONE | Average | 7 Average | 1715 | ? | 1995 | 0.0 | 98003 | 47.3097 | -122.327 | 2238 | 6819 |
| 7 | 2008000270 | 1/15/2015 | 291850.0 | 3 | 1.50 | 1060 | 9711 | 1.0 | NO | NaN | Average | 7 Average | 1060 | 0.0 | 1963 | 0.0 | 98198 | 47.4095 | -122.315 | 1650 | 9711 |
| 8 | 2414600126 | 4/15/2015 | 229500.0 | 3 | 1.00 | 1780 | 7470 | 1.0 | NO | NONE | Average | 7 Average | 1050 | 730.0 | 1960 | 0.0 | 98146 | 47.5123 | -122.337 | 1780 | 8113 |
| 9 | 3793500160 | 3/12/2015 | 323000.0 | 3 | 2.50 | 1890 | 6560 | 2.0 | NO | NONE | Average | 7 Average | 1890 | 0.0 | 2003 | 0.0 | 98038 | 47.3684 | -122.031 | 2390 | 7570 |
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21587 | 7852140040 | 8/25/2014 | 507250.0 | 3 | 2.50 | 2270 | 5536 | 2.0 | NaN | NONE | Average | 8 Good | 2270 | 0.0 | 2003 | 0.0 | 98065 | 47.5389 | -121.881 | 2270 | 5731 |
| 21588 | 9834201367 | 1/26/2015 | 429000.0 | 3 | 2.00 | 1490 | 1126 | 3.0 | NO | NONE | Average | 8 Good | 1490 | 0.0 | 2014 | 0.0 | 98144 | 47.5699 | -122.288 | 1400 | 1230 |
| 21589 | 3448900210 | 10/14/2014 | 610685.0 | 4 | 2.50 | 2520 | 6023 | 2.0 | NO | NaN | Average | 9 Better | 2520 | 0.0 | 2014 | 0.0 | 98056 | 47.5137 | -122.167 | 2520 | 6023 |
| 21590 | 7936000429 | 3/26/2015 | 1010000.0 | 4 | 3.50 | 3510 | 7200 | 2.0 | NO | NONE | Average | 9 Better | 2600 | 910.0 | 2009 | 0.0 | 98136 | 47.5537 | -122.398 | 2050 | 6200 |
| 21591 | 2997800021 | 2/19/2015 | 475000.0 | 3 | 2.50 | 1310 | 1294 | 2.0 | NO | NONE | Average | 8 Good | 1180 | 130.0 | 2008 | 0.0 | 98116 | 47.5773 | -122.409 | 1330 | 1265 |
| 21592 | 263000018 | 5/21/2014 | 360000.0 | 3 | 2.50 | 1530 | 1131 | 3.0 | NO | NONE | Average | 8 Good | 1530 | 0.0 | 2009 | 0.0 | 98103 | 47.6993 | -122.346 | 1530 | 1509 |
| 21593 | 6600060120 | 2/23/2015 | 400000.0 | 4 | 2.50 | 2310 | 5813 | 2.0 | NO | NONE | Average | 8 Good | 2310 | 0.0 | 2014 | 0.0 | 98146 | 47.5107 | -122.362 | 1830 | 7200 |
| 21594 | 1523300141 | 6/23/2014 | 402101.0 | 2 | 0.75 | 1020 | 1350 | 2.0 | NO | NONE | Average | 7 Average | 1020 | 0.0 | 2009 | 0.0 | 98144 | 47.5944 | -122.299 | 1020 | 2007 |
| 21595 | 291310100 | 1/16/2015 | 400000.0 | 3 | 2.50 | 1600 | 2388 | 2.0 | NaN | NONE | Average | 8 Good | 1600 | 0.0 | 2004 | 0.0 | 98027 | 47.5345 | -122.069 | 1410 | 1287 |
| 21596 | 1523300157 | 10/15/2014 | 325000.0 | 2 | 0.75 | 1020 | 1076 | 2.0 | NO | NONE | Average | 7 Average | 1020 | 0.0 | 2008 | 0.0 | 98144 | 47.5941 | -122.299 | 1020 | 1357 |